package com.b2bpsssm.mapper;
//    收款单表

import com.b2bpsssm.pojo.SalesPassOrder;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ReceiptMapper {
    // 有分页查询信息
    List<SalesPassOrder> queryReceiptList(@Param("start") Integer start, @Param("off") Integer off) ;

    //  根据单据编号查询数据
   List<SalesPassOrder> queryReceiptByNumber(String document_no);

    // 根据付款方查询
   List<SalesPassOrder> queryReceiptByPayer(@Param("start") Integer start, @Param("off") Integer off, @Param("customer") String customer);

    //添加收款信息
      int addReceipt(SalesPassOrder salesPassOrder);

    //    以付款方关键字 时间范围 进行关键字查询
    List<SalesPassOrder> selReceiptLikeReceiptPayer(@Param("start") Integer start, @Param("off") Integer off, @Param("sub_date1") String sub_date1, @Param("sub_date2") String sub_date2, @Param("customer") String customer);

}
